sql 单表多字段查询,查出下表3个(或更多)字段中,任意带有12字符串的数据...答:11 COLUMNPROPERTY(a.id,a.name,'PRECISION') as 长度,12 isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as 小数位数,(case when a.isnullable=1 then '√'else '' end) 允许空,13 isnull(e.text,'') 默认值,isnull(g.[value], ' ') AS [说明]14 FROM syscolumns a 15 left...